package com.googlecode.jmicroerp.repository;

import com.googlecode.jmicroerp.model.Bon;
import java.math.BigDecimal;
import java.util.Date;
import java.util.List;
import org.springframework.data.repository.CrudRepository;

/**
 *
 * @author Alexandru.Codescu
 */
public interface BonRepository extends CrudRepository<Bon, Long> {
    List<Object[]> queryBonuriProduseByMagazin(Date dataStart, Date dataEnd, Long id);
    List<BigDecimal> queryCantitateProduseByMagazin(Date data, Long idM, Long idP);
    List<BigDecimal> queryCantitateProduseByMagazinByDay(Long idM, Long idP, Date dataStart, Date DataEnd );
    List<Object[]> queryBonuriByMagazin(Date data);
    List<Object[]> queryBonuri(Date data);
    List<BigDecimal> queryVanzariAzi(Date data);
    List<BigDecimal> queryVanzariAziByMagazin(Date data, Long id);
    List<BigDecimal> queryVanzariByMagazin(Date dataStart, Date dataEnd, Long id);
}
